INSERT INTO role (id, version, authority) VALUES ('1', '0', 'ROLE_ADMIN');
INSERT INTO role VALUES ('2', '0', 'ROLE_AGENT');

INSERT INTO level VALUES (1, 0, NOW(), NOW(), 'COUNTRY');
INSERT INTO level VALUES (2, 0, NOW(), NOW(), 'REGION', 1);
INSERT INTO level VALUES (3, 0, NOW(), NOW(), 'STATE', 2);
INSERT INTO level VALUES (4, 0, NOW(), NOW(), 'UT', 2);
INSERT INTO level VALUES (5, 0, NOW(), NOW(), 'DIVISION', 3);
INSERT INTO level VALUES (6, 0, NOW(), NOW(), 'DISTRICT', 3);
INSERT INTO level VALUES (7, 0, NOW(), NOW(), 'DEPARTEMENT', 3);
INSERT INTO level VALUES (8, 0, NOW(), NOW(), 'VILLAGE', 5);
INSERT INTO level VALUES (9, 0, NOW(), NOW(), 'CITY', 5);

INSERT INTO locality (id, version, date_created, last_updated, level_id, name) VALUES (1, 0, NOW(), NOW(), 1, "France");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name)
VALUES (2, 0, NOW(), NOW(), 2, 1, "PACA");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name)
VALUES (3, 0, NOW(), NOW(), 2, 1, "RHONE-ALPES");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name)
VALUES (4, 0, NOW(), NOW(), 7, 2, "ALPES-MARITIMES");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name)
VALUES (5, 0, NOW(), NOW(), 7, 3, "RHONE");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name)
VALUES (6, 0, NOW(), NOW(), 9, 3, "LOIRE");
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name, longitude, latitude)
VALUES (7, 0, NOW(), NOW(), 9, 4, "NICE", 43.706708, 7.247416);
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name, longitude, latitude)
VALUES (8, 0, NOW(), NOW(), 9, 5, "LYON", 45.763068, 4.8300085);
INSERT INTO locality (id, version, date_created, last_updated, level_id, locality_parent_id, name, longitude, latitude)
VALUES (9, 0, NOW(), NOW(), 9, 6, "SAINT-ETIENNE", 45.442163, 4.390632);

/*TODO Est ce normal d'avoir les coordonées GPS sur les localités et pas sur les adresses ?*/
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (1, 0, 1, "NICE", "Rue Smollet", "17", "06000");
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (2, 0, 1, "NICE", "Rue Robert Latouche", "25", "06200");
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (3, 0, 1, "LYON", "Rue Smollet", "17", "06000");
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (4, 0, 1, "LYON", "Rue Smollet", "17", "06000");
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (5, 0, 1, "SAINT-ETIENNE", "Rue Smollet", "17", "06000");
INSERT INTO address (id, version, locality_id, locality_name, name_street, num_street, zip_code)
VALUES (5, 0, 1, "SAINT-ETIENNE", "Rue Smollet", "17", "06000");

